This article is about to enable spell checker functionality on update event of Memo field. The spell checker option mostly used in those databases where comments are added frequently. For that spell checker options become key feature. For implement the spell checker we are using VBA code on after update event of memo field. Whenever the spelling error happens the spell checker automatically detect the error when we are saving the text.

To implement spell checker firstly we have to create a table and form with text filed. Bind this form with table and text-box with its text field as shown in Fig 1.1.

Now we have to implement spell checker on after update event of textbox. After implementation we have to test spell checker. As we save misspelling text the spell checker automatically detect the error and provide the suggestions to correct it as shown in Fig 1.2.

As we check the on ok button the spelling is change to correct one as shown in Fig 1.3.

VBA code

Option Compare Database Private Sub txtTest_AfterUpdate()
If Len(Me!txtTest & "") > 0 Then
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True
Else
Exit Sub
End If
End Sub